package com.itheima.dao;

import com.github.pagehelper.Page;
import com.itheima.domain.Assessment;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface EstimateDao {

    //@Insert("")   //风险评估查询
    @Select("select * from t_assessment")
    List<Assessment> EstimateFindAll();

    //根据姓名/手机号/档案号查询
    @Select("select code,name,date,doctor,query from t_assessment where name=#{name} or code=#{code}" )
    List<Assessment> EstimateConditionFindAll();


    @Delete("delete from t_assessment where id=#{id}")
    void deleteEstimate(Assessment assessment);


}
